IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'RatingTypeGetByID')
	BEGIN
		DROP  Procedure  RatingTypeGetByID
	END

GO

CREATE Procedure RatingTypeGetByID
(
	@RatingTypeID int
)
AS

SELECT RatingTypeID
	, [Name]
	, [Value]
FROM RatingTypes
WHERE RatingTypeID = @RatingTypeID
